/*
 * Copyright (c) 2013, TheGhost
 *
 * All rights reserved.
 *
 * Redistribution and use in source and binary forms, with or without modification,
 * are permitted provided that the following conditions are met:
 *
 *     * Redistributions of source code must retain the above copyright notice, this
 *       list of conditions and the following disclaimer.
 *     * Redistributions in binary form must reproduce the above copyright notice, this
 *       list of conditions and the following disclaimer in the documentation and/or other
 *       materials provided with the distribution.
 *     * Neither the name of the product nor the names of its contributors may be used
 *       to endorse or promote products derived from this software without specific prior
 *       written permission.
 *
 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
 * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
 * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
 * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR
 * CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
 * EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
 * PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR
 * PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF
 * LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING
 * NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
 * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
 */

function mysqlConnect ( localhost, user, pass, db )
{
	sql <- mysql ( localhost.tostring ( ), user.tostring ( ), pass.tostring ( ), db.tostring ( ) );
	if ( sql )
		return sql;
	return false;
}

function mysqlGetTable ( handler, table )
{
	local query = "SELECT * FROM " + handler.escape_string ( table.tostring ( ) );
	
	local result = handler.query_assoc ( query );
	if ( result )
		return result;
	return false;
}

function mysqlGetRowFromTable ( handler, table, row )
{
	local query = "SELECT * FROM " + handler.escape_string ( table.tostring ( ) ) + " WHERE " + row + " = ";
	if ( typeof ( rowvalue ) == "integer" )
		query = query + rowvalue;
	else if ( typeof ( rowvalue ) == "string" )
		query = query + "'" + handler.escape_string ( rowvalue ) +"'";
	else
		return false;
		
	local result = handler.query_assoc ( query );
	if ( result )
		return result;
	return false;
}

function mysqlGetFieldFromRow ( handler, table, rowvalue, field, row = "id" )
{
	local query = "SELECT " + handler.escape_string ( field.tostring ( ) ) + " FROM " + handler.escape_string ( table.tostring ( ) ) + " WHERE " + row + " = ";
	if ( typeof ( rowvalue ) == "integer" )
		query = query + rowvalue;
	else if ( typeof ( rowvalue ) == "string" )
		query = query + "'" + handler.escape_string ( rowvalue ) +"'";
	else
		return false;
		
	local result = handler.query_assoc ( query );
	if ( result )
		return result;
	return false;
}